Use the Parameters properties page to view or modify parameter settings for a parameterized report.
Parameters are specified in the report definition before the report is published. After the report is published, you can modify some parameter property values. The values that you can modify will vary based on how the parameters are defined in the report. For example, if a list of static values is defined for a parameter, you can choose a different static value to use as a default, but you cannot add or remove values from the list. Similarly, if the parameter is based on a query, all aspects of that query (including the data set that is used, whether null or blank values are allowed, and whether a default value is provided) are defined in the report prior to publication.
To open this page, select a report, click the Properties tab at the top of the page, and then click the Parameters tab at the side of the page. If the Parameters tab is not visible, the report does not contain parameters. For more information about defining and setting parameter values, search Reporting Services Books Online.
Parameter Name
Specifies the name of the parameter.
Data Type
Specifies the data type of the parameter.
Has Default
Select this check box to specify whether the parameter has a default value. If Has Default is not selected, users must specify a parameter value to use with the report. Selecting this check box enables Default Value and Null.
Default Value
Specify a value for the parameter. To specify a default value, Has Default must be select, and Null must not be selected. A default value may be provided through the report definition. If Default Value is populated with one or more static values, those values originate with the report. If Default value is Query Based, the parameter value is determined by a query that is defined in the report.
If Default Value accepts a value, you can type a constant or syntax that is valid for the data processing extension used with the report. For example, if the query language of the data processing extension supports wildcards, you can specify a wildcard character as a default value.
If you subsequently specify that a prompt be displayed to the user, the default value becomes an initial value that users can either use or modify. If you do not prompt for a parameter value, this value is used for all users who run the report.
Null
Select this check box to specify null as the default value. A null value means that the report runs even if the user does not provide a parameter value. If there is no check box in this column, the parameter does not accept null values.
Prompt
Select this check box to display a text box used that prompts users for a parameter value.
Clear this check box if you want to run the report in unattended mode (for example, to generate report history or report execution snapshots), if you want to use the same parameter value for all users, or if you do not require user input for the value.
Prompt String
Provide a text string that appears next to the parameter text box. This string provides a label or descriptive text. There is no limit on string length. Longer text strings wrap within the space provided.
General Properties Page (Reports)
Installing and Using Reporting Services Books Online
Copyright 2003. All Rights Reserved